Calculated Field Expression Dialog Box

Use this dialog box to create the calculated field expression.

Contents

Field Description
Name This field is read-only and displays the name of the field entered on the New Calculated Field dialog box.
Expression Use this field to create the expression.
  • The expression may contain mathematical operators:
    • Add (+)
    • Subtract (-)
    • Multiply (*)
    • Divide (/)
    • Group (( ))
  • The expression may contain any property from the Applies to Table field that has a numeric data type.
  • Mathematical operators are evaluated according to the normal rules of precedence:
    • Cobra performs grouping operations before multiplication and division operations.
    • Cobra performs multiplication and division operations before addition and subtraction operations.
Applies to Table This field is read-only and displays the value selected on the New Calculated Field dialog box.
Data Type Use this drop-down list to select the data type. Your options are:
  • Integer
  • Decimal
Note: This drop-down list does not filter the fields displayed on the Fields dialog box. Cobra allows you to select integer and decimal data types; nullable data types will be supported in future releases.
Currency This check box is currently not in use but will be required in future releases.
Fields... Click this button to display the Fields dialog box.